SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbrelevamientopredio
AS
SELECT     dbo.u_f1_00_varios.Id, dbo.u_cui.cui, dbo.u_tp_tipoorgnoedu.descripcion AS TipoOrganizacion, dbo.u_cui.direccion, dbo.u_cui.departamento, 
                      dbo.u_f1_00_varios.observaciones, dbo.u_f1_00_varios.idCui
FROM         dbo.u_f1_00_varios INNER JOIN
                      dbo.u_cui ON dbo.u_f1_00_varios.Id = dbo.u_cui.Id INNER JOIN
                      dbo.u_tp_tipoorgnoedu ON dbo.u_f1_00_varios.idTipoPredNoEsc = dbo.u_tp_tipoorgnoedu.id
GO
GRANT SELECT ON  [dbo].[vwbrelevamientopredio] TO [Cenie]
GO
